Skip to main content

GetSheet

Returns an object that represents a sheet.

Syntax

expression.GetSheet(nameOrIndex);

expression - A variable that represents a Api class.

Parameters

NameRequired/OptionalData typeDefaultDescription
nameOrIndexRequiredstringnumber

Returns

ApiWorksheet | null

Example

This example shows how to get an object that represents a sheet.

var oWorksheet = Api.GetSheet("Sheet1");
oWorksheet.GetRange("A1").SetValue("This is a sample text on 'Sheet1'.");